package com.demo.test.repository.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;

import com.bluering.framework.common.base.BaseMapper;
import com.demo.test.repository.model.OcsSysUser;
import com.demo.test.repository.sqlprovider.TestUserProvider;

public interface OcsSysUserMapper extends BaseMapper<OcsSysUser> {
	
	@Select("SELECT * FROM ocs_sys_user t where t.status=#{status,jdbcType=NUMERIC}")
	public List<OcsSysUser> getUserByStatus(@Param("status")Integer status);
	
	@SelectProvider(type=TestUserProvider.class,method="getUserByPhoneSQL")
	public List<OcsSysUser> getUserByPhone(@Param("phone")String phone,@Param("username")String username);
	
}